HyperlinkFunction

Returns the formula for a hyperlink [=Hyperlink(...) ] to be inserted in a cell. ...

Shape_Select_or_CreateThenSelect

Selects a shape inside sheet to change it, or if not found, it will create it ...

Range2ANStr

Converts sheet range to ANString, can work on any continued range, 1 or 2 ...

ANmaSQL_UpdateDateStatement

Creates "Update Table " SQL statements to be executed inside SQL to modify ...

Export2CSV

Exports a sheet into CSV file Dynamically finds number of rows/columns and ...

ShapeName clicked

Simple command to know which object (shape) the user clicked When you assign a ...

CSVs2Sheets

Import all CSVs found in a folder into sheets, sheet per CSV This was a quick ...

CSVs2Sheetsv0.2.xlsb.zip

merge2Arrays

Merges two 1-dimension arrays and return an array Both should be 1 dimensional ...

Frm6 - ANmaMultiSelect

Give users ability to multi-select from list of items into cells with separator. ...

Frm6.zip

RandomUniqueID_Sheet

Inserts numeric random unique ID in a column in sheet, specify column, sheet, ...

Execute exe embedded in Excel

Execute exe file that embed inside Excel sheet This is for experimental, not ...

Excel crashes when File > Print

During generating Print Preview, Excel crashes. Applies to some files, not all, ...